Nuacht

Ars Technica6y

Use Excel cell A2 as database query to populate B2 and C2?

I'd like to type " XYZ1234 " as the Item_ID in cell A2 and have it return " ACME Rocket Car 2.0 " as the Item_Name in B2 and " 5 " as my OnHandQty in C2.