Hi, I have column 1 with a dropdown field in a cell, columns to the left have dropdown field names like forumula1, forumula2,forumula3,forumula4
Below are rows with data.
Please see attached file to see what I mean. I tried using hlookup but it does not work.
Try this formula in D8, and fill down
=HLOOKUP($D$7,$E$7:$H$28,ROWS(D$7:D8),0)
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
=HLOOKUP($D$7,$E$7:$H$28,ROW(C2),FALSE)
and copy down.
Regards, TMS
Last edited by TMS; 05-03-2012 at 11:38 AM. Reason: My 6000th post ;-)
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you it worked fineOriginally Posted by DGagnon
Glad to help, could you please mark as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks