•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Return Value if Match header in Column
How do write a formula in the "RETURN VALUE" Column that will look at the 1st column "Job" and compare the value with the header in that same row and populate the dollar value.
eg. Job D, compares to the header in that row and returns the value of $30.
| JOB | RETURN VALUE | A | B | C | D |
|---|---|---|---|---|---|
| A | $15 | $15 | $16 | $17 | $18 |
| D | $30 | $20 | $18 | $16 | $30 |
| B | $16 | $14 | $16 | $18 | $20 |
| C | $17 | $15 | $16 | $17 | $30 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#RETURN VALUE
#Job
#formula
#compare
#header
#$30
#$15
#$16
#$17
#$18
#$20
#$14