vlookup

J

Janis

Something is wrong with my vlookup. It doesn't update my columne I want to
find every cell in column "I" that is over 50% in this 98th percentile report
(rows I4::3205) and put it in column "AM" a blank column in the active
worksheet called History, on the HSI sheet.

=VLOOKUP(">50.00",I:'[07-0714 Bay-Downstream Ports 98th
Percentile.xls]History'!$I$4,3205,HSI!)

Can you tell me what I did wrong with the vlookup?

tia,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top