Función buscarv de excel

Tengo 3 hojas con información de productos, código, cantidad en excel y quiero que al colocar un código en una de las hojas, sino lo lo encuentra en la hoja1 lo busque en la hoja 2 o en la 3, pero no se cual seria la fórmula, lo he intentado pero no sale.
Ayúdenme de antemano gracias.

1 respuesta

Respuesta
1
=SI(A2<=3;BUSCARV(A2;'Productos 1'!A1:C4;2);BUSCARV(A2;'Productos 2'!A1:C4;2))
Función SI, trata con ésta. No está completa por tu bien, si tienes más dudas, contáctame.

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas

What is popular dating sites or apps

When considering popular dating sites or apps, it's crucial to evaluate several key criteria before diving into the world of online dating. With countless options available, finding the right platform can significantly impact your overall experience...
3 respuestas

Dumps Queen Your Path to SAP Certification Success

Each set of SAP Certification Dumps SAP Study Materials includes real-world scenarios so you can relate the questions to practical situations. This approach helps in better understanding and increases your chances of passing the certification with...
2 respuestas

Why Bright-Star Fireworks is the Top Choice for Events in Tasmania

With their combination of expert knowledge, high-quality products, customizable packages, and excellent customer support, Bright-Star Fireworks remains the premier choice for fireworks in Tasmania. Whether you're organizing a wedding, corporate...
3 respuestas

The Keys to Successful Soccer Betting (Strategies)

The following are the strategies you should learn to become a successful soccer bettor; 1. Do A Little Research Performing a little research is one of the critical components of successful betting. Pay attention to the players, and team performances...
2 respuestas

Downloadtopten OST to PST Converter

Its best brand name for Converting OST to PST with all OST mailbox properties such as attachments, emails, notes, tasks, journals, appointments, massages, and meta properties such as To, From, Subject, CC, BCC, and so on is Downloadtopten OST to PST...
12 respuestas

What is the best entertainment and movies streaming app?

¿Tired of low-quality streams and endless ads? Loklok Premium APK changes the game—offering ad-free access to blockbuster movies, trending TV shows, and anime in crystal-clear HD. No subscriptions, no limits, just non-stop entertainment in your...
3 respuestas

Manage your Chromebook's languagesTap here to see an interactive tutorial.

Manage your Chromebook's languages Tap here to see an interactive tutorial Change your device's language Your Chromebook’s features, like settings and menus, use the language you chose when you first set up your device. At the bottom right, select...
8 respuestas

ChatGPT Polsku: Innowacyjne Rozwiązania dla Każdego w 2024

ChatGPT Polsku, w najnowszej wersji na rok 2024, oferuje użytkownikom szeroki wachlarz unikalnych funkcji, które sprawiają, że jest to niezastąpione narzędzie w codziennym życiu. Jedną z kluczowych cech, która wyróżnia tę platformę, jest jej...
14 respuestas

Golf simulators bring the experience of playing

A golf simulator encourages a higher degree of concentration and mental discipline. With no external distractions such as changing weather, noise, or course delays, players can focus entirely on their game. Many simulators include features like...
5 respuestas

Can you develop professional skills through games?

Games are not simply entertainment but also a powerful tool to help develop effective career skills. Specially designed games can help players practice and develop many important skills, from time management skills, strategic thinking, to problem...
2 respuestas