Forum Discussion
jthorpe222
Jun 23, 2022Copper Contributor
VLookup using a cell number
Hello - I am using Spread sheet compare and my result have what cells were changed but I need to know what account number they go with: Sheet 1 (compare results shows cells changed) A50 A2...
OliverScheurich
Jun 23, 2022Gold Contributor
=VLOOKUP(IF(ISNUMBER(NUMBERVALUE(MID(A1,2,1))),NUMBERVALUE(MID(A1,2,LEN(A1)-1)),IF(ISNUMBER(NUMBERVALUE(MID(A1,3,1))),NUMBERVALUE(MID(A1,3,LEN(A1)-1)),NUMBERVALUE(MID(A1,4,LEN(A1)-1)))),CHOOSE({1,2},ROW(Tabelle2!$A$1:$A$26),Tabelle2!$A$1:$A$26),2,FALSE)Is the result in the attached file similar to what you want to do?