VLOOKUP population

[kryt0n]

Hi all,

So on the attached example.xls I have a drop down menu on sheet calcs. I want to know how select from the list and then populate the cells below.

I cannot work out how to format the if function so that it stays for that row but the column selection changes...

any help would be appreciated.

[zbor]

Here, try this:

=INDEX(Clothes!$A$1:$F$14, 1+ROWS($A$1:A1), MATCH($B$2, Clothes, 0))

[kryt0n]

LEGEND!!!!
Thank you so much! It's been killing me for 2 hours!

*hugs zbor*

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.