mardi 10 juillet 2018

alter Lookup based on another value

If a cell A1 displays an H, i'd like A3 to use a Vlookup. If A1 is then changed to an F, i'd like A3 to use a different Vlookup table. I'm unsure how to do this in Excel.. can anyone help?

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire