- Get link
- X
- Other Apps
Labels:
Excel videos
office 365 functions
Vlookup
- Get link
- X
- Other Apps
The VLOOKUP function in Excel can be used with wildcard characters to find and retrieve data based on a partial match of a lookup value. The wildcard characters that can be used with VLOOKUP are the "*" (asterisk) and "?" (question mark) characters. The "*" (asterisk) character is used to match any sequence of characters, while the "?" (question mark) character is used to match any single character. To use a wildcard character with VLOOKUP, you need to include the wildcard character in the lookup value within quotation marks. For example, to find the price of a product that starts with the letter "A" and has any number of characters after it, you can use the following formula: =VLOOKUP("A*",A1:C10,3,FALSE) This formula will look for the value "A*" in the first column of the range A1:C10, and if it finds a match, it will return the value in the third column of the same row. Similarly, if you want to find a pro...
ReplyDeleteWow your blog sach me bahut hi lajawab hai mene adhi Jayada information apne collages ke project submit ki hai jisme ye batya gye hai compute course kitna jada benefir course hai computer ki jarurat har sector me padti hai or apko blog me article computer ke bare me maja a gye sach thanks you ese article submit karne ke liye
Graphic Designing course in Delhi NCR,
Best computer course in Delhi
Best Fine art Institute in Delhi