إسأل Computer & Phone Engineer الآن

Eng. Rawan Al Remawi

Eng. Rawan Al Remawi

Computer & Phone Engineer

الأسئلة المجابة 14191 | نسبة الرضا 97.9%

Computer/IT Expert
تم تقييم هذه الإجابة:

how can i use xlookup in excel?

إطرح سؤالك

إجابة الخبير: Eng. Rawan Al Remawi

Eng. Rawan Al Remawi

Eng. Rawan Al Remawi

Computer & Phone Engineer

الأسئلة المجابة 14191 | نسبة الرضا 97.9%

1) Start formula
Create new destination column (Qty Available). start the formula, enter the following into the field where you want the value to go:
=vlookup(
 choose the cell (in my case, the SKU) in that row that you want to search for in your other sheet. , add a comma.

2) Tell Vlookup where to search
Go to the other sheet, and select the group of columns in which you wish to search.
You’ll want to start with your SKU column, press  column and hold, drag over to the column where your target value  sits, and release. Add another comma.
 now selected a group of columns that Vlookup will use to execute your search. 

3) Tell Vlookup number of columns between your values

4) type  a 0

إسأل Computer & Phone Engineer

Eng. Rawan Al Remawi

Eng. Rawan Al Remawi

Computer & Phone Engineer

الأسئلة المجابة 14191 | نسبة الرضا 97.9%

  • 100% ضمان الرضا
  • انضم الى 8 مليون من العملاء الراضين
المحادثات تتم ضمن هذه البنود

في الأخبار