Forum Discussion
Excel - IF?
Hi, does anybody know which function in excel is right to do - see below: If in the column A1 is a Company City (there are more of them according to cities, i.e. company London, company Prague, c...
=INDEX($J$2:$K$7,MATCH(B1,$I$2:$I$7,0),MATCH(A1,$J$1:$K$1,0))I'd create a lookup table as shown in the screenshot in columns I to K.
Thank you, i did it with with using IF with LEFT and VLOOKUP and two databases of products. 😅