Forum Discussion

Copper Contributor

Aug 12, 2022

Vlookup

Hey Guys. I'm hoping someone can assist me but my vlookup doesn't seem to be searching the whole sheet, Just the first column. Vlookup, Excel I'm using =VLOOKUP(A2, Sheet1!A:AJ, 2, FALSE) Can ...

excel

dscheikey

Bronze Contributor

Aug 12, 2022

This is exactly what VLOOKUP() does. It searches the first column and returns the content according to the column index.
See also here:
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
What did you want to achieve?

Jamesboden

Copper Contributor

Aug 12, 2022

Hey. I want to look up to search the whole of sheet1.

HansVogelaar
MVP
Aug 12, 2022
Jamesboden

So what exactly do you want to do if the word "Success" is found anywhere in the sheet?
- Jamesboden
  Copper Contributor
  Aug 12, 2022
  so everything has a postcode in the next collum. So if it finds Success anywhere I want it to return the postcode for it.
  - SergeiBaklan
    Diamond Contributor
    Aug 12, 2022
    Jamesboden
    
    As variant
    
    =INDEX( Sheet1!A1:X1000, SUMPRODUCT( ( Sheet1!A1:X1000="Success")*ROW(Sheet1!A1:X1000) ) - ROW(Sheet1!$A$1)+1, SUMPRODUCT( ( Sheet1!A1:X1000="Success")*COLUMN(Sheet1!A1:X1000) ) - COLUMN(Sheet1!$A$1)+1 +1 )