hi all,
I'm pretty new to the excel thing and I have inherited a spreadsheet that I am trying to decipher and one column of data is produced with a vlookup formula: VLOOKUP(S67,POCategory,2,TRUE)
I don't understand how "PO category" can take the place of a normal array ie. $A$1:$D$8,
and I can't find the table the formula is looking up in the spreadsheet anywhere.
Any ideas on how to find this array?
Thanks
someone has named the range
have a look in insert/names/define you should see the name and range referenced there
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks