ExcelBanter - vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/151711-vlookup.html)

Janis

vlookup

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,

Janis

vlookup

I will repost because this is confusing.

"Janis" wrote:

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,

All times are GMT +1. The time now is 11:31 PM.