Oh man you explain this so good! I was wondering if this was possible I have 2 columns Both with drop down selections One for company one for status I was wondering If i have a bunch of tabs Could I for example grab Company drop down = untied Status drop down = done From all the tabs And have it grab the “address” column for everything that has the drop down columns set to “united” & “done” And have it populate in a new tab for an invoice? My boyfriend has a company and he does jobs for different companies and some of them require him to submit his invoice for each pay period. It would be so nice if I could have it go through each employees tab and grab the address needed for the invoice and have it automatically populate on a different tab so he could make an invoice that saves him time and to ensures he doesn’t miss anything. I’m just trying to help him so he can run his small business more efficiently I feel like this VLOOKUP might be the solution I’m looking for but just wanted to get your opinion to see if it would work Thank you so much for any help and advice and for making such helpful videos you explain and show everything so well!!
Give these steps a try: Step 1: Create your lookup table: This table should have the word you want to search for in the first column and the corresponding value you want to return in another column. Step 2: Create a dropdown list: Select the cell where you want the dropdown. Go to Data > Data validation. Under "Criteria," choose "List from a range" or "List of items" and specify your word options. Step 3: Use VLOOKUP: In the cell where you want the result, enter the VLOOKUP formula: =VLOOKUP(A1, Sheet1!A1:B10, 2, FALSE) Replace A1 with the cell containing the dropdown. Replace Sheet1!A1:B10 with the correct sheet name and range of your lookup table. Replace 2 with the column number in your lookup table containing the value you want to return. FALSE ensures an exact match to the word in the dropdown.
Nice video! Is there also an advance vlookup setup?
Beautiful. Great teaching skill!
Thank you so much, really helpful. Amazing 👏👏
Brilliant! Amazing videos as always!🤗
Thank you! Cheers!
انا المشاهد الثاني ❤🎉
Thank you so much
You’re welcome!
I appreciate your efforts///
Very helpful! 👏🏽👏🏽👏🏽
Glad you think so!
Oh man you explain this so good!
I was wondering if this was possible
I have 2 columns
Both with drop down selections
One for company one for status
I was wondering
If i have a bunch of tabs
Could I for example grab
Company drop down = untied
Status drop down = done
From all the tabs
And have it grab the “address” column for everything that has the drop down columns set to “united” & “done”
And have it populate in a new tab for an invoice?
My boyfriend has a company and he does jobs for different companies and some of them require him to submit his invoice for each pay period.
It would be so nice if I could have it go through each employees tab and grab the address needed for the invoice and have it automatically populate on a different tab so he could make an invoice that saves him time and to ensures he doesn’t miss anything.
I’m just trying to help him so he can run his small business more efficiently
I feel like this VLOOKUP might be the solution I’m looking for but just wanted to get your opinion to see if it would work
Thank you so much for any help and advice and for making such helpful videos you explain and show everything so well!!
Does it work with new Tables feature?
Is there a way to use VLOOKUP with a dropdown formatted cell using words? I have it working with numbers,
Give these steps a try:
Step 1: Create your lookup table: This table should have the word you want to search for in the first column and the corresponding value you want to return in another column.
Step 2: Create a dropdown list:
Select the cell where you want the dropdown.
Go to Data > Data validation.
Under "Criteria," choose "List from a range" or "List of items" and specify your word options.
Step 3: Use VLOOKUP:
In the cell where you want the result, enter the VLOOKUP formula:
=VLOOKUP(A1, Sheet1!A1:B10, 2, FALSE)
Replace A1 with the cell containing the dropdown.
Replace Sheet1!A1:B10 with the correct sheet name and range of your lookup table.
Replace 2 with the column number in your lookup table containing the value you want to return.
FALSE ensures an exact match to the word in the dropdown.
@TeachersTech Ah, the first column... That was the problem. I fixed it by using xlookup instead.
Very clear thanks
You are welcome
thanks
👏👏👏
I m your first viewer🎉
How about time sheet video?🤔
Make budget