Vlookup multiple sheet issues

IN column AQ of sheet "select__from_a_csv" i want to display "PSC" if worksheet "Parcel_csv" column 1 = "44295"

AQ of sheet "select__from_a_csv" should also = "PRI" If worksheet "Parcel_csv" column 1 = anything else.

Thankyou to everyone for your help, soon i will get my head around vlookup.

WeedMan

IN column AQ of sheet "select__from_a_csv" i want to display "PSC" if worksheet "Parcel_csv" column 1 = "44295"

If which row of column 1 = 44295 ?? The first row? The same row as the formula in the "select from csv" sheet? A row that is found by a lookup?

Please give an example.

Sorry for the confusion, it is column A in the worksheet called "Parcel_csv"

You will notice the values in that column are either 44295 or a bunch of other random numbers.

If column A in the worksheet called "Parcel_csv" = 44295, i would like column AQ of sheet "select__from_a_csv" to display "PSC".

If column A in the worksheet called "Parcel_csv" = an other number, i would like column AQ of sheet "select__from_a_csv" to display "PRI".

Sorry for the confusion, it is column A in the worksheet called "Parcel_csv"

I realise that.

If column A in the worksheet called "Parcel_csv" = 44295

in which row of column A ??? What row do you want to look at in your formula in sheet "select__from_a_csv" ??

So, cell AQ2 of "select__from_a_csv" -- which row of "Parcel_csv" column A do you want to check?

cell AQ3 of "select__from_a_csv" -- which row of Parcel_csv" column A?
cell AQ4 of "select__from_a_csv" -- which row of Parcel_csv" column A?
cell AQ5 of "select__from_a_csv" -- which row of Parcel_csv" column A?

etc.

But which row do you want the comparison performed with for each row? If it's row, by row, just use an IF statement.

=if(Parcel_csv!A2=44295,"PSC","PRI")

copy down. But I bet you'll come back and say it's more complex than this.