Need help with index, match, offset formula

It is not clear to me what you want, but I have a suggestion to fix VLOOKUP.
=IFERROR(VLOOKUP($A5,'data dump'!$B$5:$M$7,COLUMN()-1,0),"")

You mentioned VLOOKUP, but didn't finish the sentence. Were you doing to say it was not working?

This formula can be used, pointing to the range for Unit 1. (The COLUMN() makes it easy to copy down and across, without having to edit every cell!)

It won't work for Variable 2 because there is a typo in the data. There is an extra space at the end of variable 2 on the Data Dump sheet.

Does this help, or are you trying to get more complex?


Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".