Hi All,
I have for me a difficult question to explain. I am trying to create a formula that I believe would need to use a VLOOKUP and a HLOOKUP. Would anybody know how to create that formula in the attached document?
Thank you for any and all help!!
Sean
you can try with: INDEX(range, MATCH(), MATCH() )
first match is like Vlookup, second like Hlookup
This in C3 copied across and down:
=INDEX('Data File'!$B$2:$AO$430,MATCH('Sheet I need Filled in'!C$2,'Data File'!$A$2:$A$430,0),MATCH('Sheet I need Filled in'!$B3,'Data File'!$B$1:$AO$1,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you so much!!
If the problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
- mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,
Thanks
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks