Problem coming in using vlookup formula in spreadsheet

59 views Asked by At

enter image description here I want get value in CV of DA if CZ contains value of CR. Here we are matching CR username with CZ user id if its matching then i want to print data of DA in column CV. I am working in spreadsheet. I tried this work with vlookup, hlookup and vlookup.

1

There are 1 answers

10
Harun24hr On

VLOOKUP() should work. Try-

=VLOOKUP(CR2,$CZ$2:$DA$5,2,0)

You can also use XLOOKUP().

=XLOOKUP(CR2,$CZ$2:$CZ$5,$DA$2:$DA$5)

enter image description here