•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
Our take
To populate the "RETURN VALUE" column based on the job listed in the first column, you'll want to use a formula that matches the job with its corresponding header. For example, if the job is "D," the formula will compare "D" to the headers in that row and return the associated dollar value. In this instance, the value of $30 will be returned from the appropriate header column. This approach simplifies tracking and managing job-specific values effectively within your spreadsheet.
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]
Read on the original site
Open the publisher's page for the full experience
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