Vlookup

B

bluenoser13

Hello:

Thanks you for your reply. I will try them to see which works best fo
me. :
 
D

Domenic

bluenoser13 said:
Hello:

Thanks you for your reply. I will try them to see which works best fo
me. :)
Click to expand...

Actually, if you prefer, you can combine my two formulas into one...

Sheet1!C2:

=IF(A2<>13,INDEX(Sheet2!B2:G6,B2,A2),SUM(INDEX(Sheet2!B2:G6,B2,0))
 
Top