How can I use Excel VLOOKUP function based on specific text and not displaying all columns [duplicate]

Question

How can I use VLOOKUP to display data from Sheet A to Sheet B based on one specific value in Sheet A cell D5. The specific value will be also located in Sheet B Cell A1.

I have tried using something like VLOOKUP($A2, sheet1!$A:$F, 1) but it has not help. Keep giving me error.

Sheet 1 (data)

Sheet 2 (result)

Which version of Excel are you using?
– Frank Ball
Commented yesterday — Frank Ball, Commented yesterday

z.. · Accepted Answer · 2025-04-24 19:26:36Z

0

Given your current setup, in Result!B3 you can use:

=XLOOKUP(A1,Sheet!F:F,Sheet1!B:F)

This returns the whole row associated to the ID in A1, if you want to exclude the Filter column, you can try:

=INDEX(XLOOKUP(A1,Sheet!F:F,Sheet1!B:F),{1,2,3,5})

answered yesterday

z..

13.4k2 gold badges9 silver badges20 bronze badges

So whenever I use '=INDEX(XLOOKUP(A1,Sheet!F:F,Sheet1!B:F),{1,2,3,5})' I get 0 0 0 0 on sheet2, I have pasted the code on sheet2 B3... So If I add any text on B1 it will show on B4. Is not showing the text associated with sheet1.
– Chris
Commented yesterday

Add a comment |

Collectives™ on Stack Overflow

How can I use Excel VLOOKUP function based on specific text and not displaying all columns [duplicate]

1 Answer 1

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Linked

Related